package com.example.demo.mapper;

import com.example.demo.entity.Comment;
import org.apache.ibatis.annotations.*;

@Mapper
public interface CommentMapper {
    @Select("SELECT * FROM t_comment WHERE id=#{id}")
    @Results(value = {
            @Result(column = "id" , property = "idx")
    })
    public Comment findById(Integer id);

    @Insert("INSERT INTO t_comment(a_id,author,content) VALUES (#{aId},#{author},#{content})")
    public int insertComment(Comment comment);

    @Update("UPDATE t_comment SET content=#{content} WHERE id=#{id}")
    public int updateComment(Comment comment);

    @Delete("DELETE FROM t_comment WHERE id=#{id}")
    public int deleteComment(Insert id);
}
